﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;

namespace DAO
{
    public class DonViTinhDAO
    {
        public static DataTable Danhsach()
        {
            string sql=string.Format("select * from DONVITINH");
            return DataProvider.ExcuteQuery(sql);
        }
        public static DataTable TenDV(int madv)
        {
            string sql = string.Format("select TENDONVI from DONVITINH where MADONVI={0}", madv);
            return DataProvider.ExcuteQuery(sql);
        }
    }
}
